loading packages
## ── Attaching packages ─────────────────────────────────────── tidyverse 1.3.2 ──
## ✔ ggplot2 3.4.0 ✔ purrr 0.3.5
## ✔ tibble 3.1.8 ✔ dplyr 1.0.10
## ✔ tidyr 1.2.1 ✔ stringr 1.4.1
## ✔ readr 2.1.3 ✔ forcats 0.5.2
## ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
## ✖ dplyr::filter() masks stats::filter()
## ✖ dplyr::lag() masks stats::lag()
## Loading required package: timechange
##
##
## Attaching package: 'lubridate'
##
##
## The following objects are masked from 'package:base':
##
## date, intersect, setdiff, union
## Rows: 8 Columns: 149
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (3): SLDUST, NAMELSAD, NAME
## dbl (146): OBJECTID, STATEFP, GEOID, ALAND, AWATER, INTPTLAT, INTPTLON, DP03...
##
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.
## Rows: 273498 Columns: 58
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (13): CCN, REPORTDATE, ROUTEID, FROMDATE, ADDRESS, WARD, EVENTID, MAR_AD...
## dbl (44): X, Y, OBJECTID, CRIMEID, MEASURE, OFFSET, STREETSEGID, ROADWAYSEGI...
## lgl (1): TODATE
##
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.
## Rows: 721264 Columns: 15
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (11): CCN, PERSONTYPE, FATAL, MAJORINJURY, MINORINJURY, VEHICLEID, INVEH...
## dbl (4): OBJECTID, CRIMEID, PERSONID, AGE
##
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.
## Rows: 60094 Columns: 18
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (3): COMMENTS, GIS_ID, GLOBALID
## dbl (10): X, Y, STREETJUNCTIONID, STREETSEGID, FACILITYID, MARKINGID, MARKIN...
## lgl (5): SE_ANNO_CAD_DATA, CREATOR, CREATED, EDITOR, EDITED
##
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.
## Rows: 71720 Columns: 61
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (45): ADDEDBY, ADDTOGIS, ARMLENGTH1_DESC, ARMLENGTH2_DESC, ARMSTYLE_DESC...
## dbl (10): X, Y, ASSETTYPE, NUMBERLIGHTS, STREETSEGMID, WARD, WATTAGE1, XCOOR...
## lgl (6): GLOBALID, GIS_ID, CREATOR, CREATED, EDITOR, EDITED
##
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.
## Rows: 314 Columns: 17
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (5): CAMERATYPE, GIS_ID, GLOBALID, EDITOR, EDITED
## dbl (9): X, Y, STREETJUNCTIONID, STREETSEGID, FACILITYID, CAMERAID, POLEID, ...
## lgl (3): SE_ANNO_CAD_DATA, CREATOR, CREATED
##
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.
## Rows: 55 Columns: 25
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (8): FACILITYID, STATIONID, STATIONABBR, STATIONTYPE, TECHNOLOGY, ADDRES...
## dbl (9): X, Y, STREETSEGID, SISID, MEASURE, MAPINSET, XCOORD, YCOORD, OBJECTID
## lgl (8): CONDITION, CONDITIONDATE, INSTALLDATE, SE_ANNO_CAD_DATA, CREATOR, C...
##
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.
## Rows: 1412 Columns: 17
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (2): GIS_ID, GLOBALID
## dbl (10): X, Y, STREETJUNCTIONID, STREETSEGID, FACILITYID, CABINETID, CABINE...
## lgl (5): SE_ANNO_CAD_DATA, CREATOR, CREATED, EDITOR, EDITED
##
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.
find common variables
## [1] "X" "Y" "FACILITYID" "GLOBALID" "GIS_ID"
## [6] "OBJECTID" "CREATOR" "CREATED" "EDITOR" "EDITED"
## # A tibble: 721,264 × 15
## OBJECTID CRIMEID CCN PERSO…¹ PERSO…² AGE FATAL MAJOR…³ MINOR…⁴ VEHIC…⁵
## <dbl> <dbl> <chr> <dbl> <chr> <dbl> <chr> <chr> <chr> <chr>
## 1 368933829 25173932 14167… 8.46e7 Driver 31 N N N 1001107
## 2 368933830 24125385 12105… 8.50e7 Driver 25 N N N 862546
## 3 371097543 24125385 12105… 8.47e7 Driver NA N N N 862545
## 4 371097544 26652669 09087… 8.50e7 Driver NA N N N 985829
## 5 371097545 26652669 09087… 8.48e7 Passen… NA N N N 985828
## 6 371097546 26652669 09087… 8.47e7 Driver 10 N N N 985828
## 7 371097547 26652669 09087… 8.48e7 Passen… NA N N N 985828
## 8 371097548 26652671 08120… 8.48e7 Driver 42 N N N 985879
## 9 371097549 26652671 08120… 8.49e7 Driver 21 N N N 985880
## 10 371097550 26651388 10174… 8.48e7 Driver 25 N N Y 902286
## # … with 721,254 more rows, 5 more variables: INVEHICLETYPE <chr>,
## # TICKETISSUED <chr>, LICENSEPLATESTATE <chr>, IMPAIRED <chr>,
## # SPEEDING <chr>, and abbreviated variable names ¹PERSONID, ²PERSONTYPE,
## # ³MAJORINJURY, ⁴MINORINJURY, ⁵VEHICLEID
## # A tibble: 1 × 58
## X Y OBJECTID CRIMEID CCN REPOR…¹ ROUTEID MEASURE OFFSET STREE…²
## <dbl> <dbl> <dbl> <dbl> <chr> <chr> <chr> <dbl> <dbl> <dbl>
## 1 -77.0 38.9 140193753 23522156 10170915 2010/1… 110872… 1395. 25.2 -9
## # … with 48 more variables: ROADWAYSEGID <dbl>, FROMDATE <chr>, TODATE <lgl>,
## # ADDRESS <chr>, LATITUDE <dbl>, LONGITUDE <dbl>, XCOORD <dbl>, YCOORD <dbl>,
## # WARD <chr>, EVENTID <chr>, MAR_ADDRESS <chr>, MAR_SCORE <dbl>,
## # MAJORINJURIES_BICYCLIST <dbl>, MINORINJURIES_BICYCLIST <dbl>,
## # UNKNOWNINJURIES_BICYCLIST <dbl>, FATAL_BICYCLIST <dbl>,
## # MAJORINJURIES_DRIVER <dbl>, MINORINJURIES_DRIVER <dbl>,
## # UNKNOWNINJURIES_DRIVER <dbl>, FATAL_DRIVER <dbl>, …
## # A tibble: 2 × 15
## OBJECTID CRIMEID CCN PERSO…¹ PERSO…² AGE FATAL MAJOR…³ MINOR…⁴ VEHIC…⁵
## <dbl> <dbl> <chr> <dbl> <chr> <dbl> <chr> <chr> <chr> <chr>
## 1 371164304 23522156 101709… 8.49e7 Driver 0 N N N 899452
## 2 371559170 23522156 101709… 8.49e7 Driver 33 N N N 899453
## # … with 5 more variables: INVEHICLETYPE <chr>, TICKETISSUED <chr>,
## # LICENSEPLATESTATE <chr>, IMPAIRED <chr>, SPEEDING <chr>, and abbreviated
## # variable names ¹PERSONID, ²PERSONTYPE, ³MAJORINJURY, ⁴MINORINJURY,
## # ⁵VEHICLEID
## # A tibble: 1 × 58
## X Y OBJECTID CRIMEID CCN REPOR…¹ ROUTEID MEASURE OFFSET STREE…²
## <dbl> <dbl> <dbl> <dbl> <chr> <chr> <chr> <dbl> <dbl> <dbl>
## 1 -77.0 38.9 140193753 23522156 10170915 2010/1… 110872… 1395. 25.2 -9
## # … with 48 more variables: ROADWAYSEGID <dbl>, FROMDATE <chr>, TODATE <lgl>,
## # ADDRESS <chr>, LATITUDE <dbl>, LONGITUDE <dbl>, XCOORD <dbl>, YCOORD <dbl>,
## # WARD <chr>, EVENTID <chr>, MAR_ADDRESS <chr>, MAR_SCORE <dbl>,
## # MAJORINJURIES_BICYCLIST <dbl>, MINORINJURIES_BICYCLIST <dbl>,
## # UNKNOWNINJURIES_BICYCLIST <dbl>, FATAL_BICYCLIST <dbl>,
## # MAJORINJURIES_DRIVER <dbl>, MINORINJURIES_DRIVER <dbl>,
## # UNKNOWNINJURIES_DRIVER <dbl>, FATAL_DRIVER <dbl>, …
## # A tibble: 0 × 15
## # … with 15 variables: OBJECTID <dbl>, CRIMEID <dbl>, CCN <chr>,
## # PERSONID <dbl>, PERSONTYPE <chr>, AGE <dbl>, FATAL <chr>,
## # MAJORINJURY <chr>, MINORINJURY <chr>, VEHICLEID <chr>, INVEHICLETYPE <chr>,
## # TICKETISSUED <chr>, LICENSEPLATESTATE <chr>, IMPAIRED <chr>, SPEEDING <chr>
combine data
## # A tibble: 1 × 69
## X Y CRIMEID CCN REPORTDATE ROUTEID MEASURE OFFSET STREETSE…¹ ROADW…²
## <int> <int> <int> <int> <int> <int> <int> <int> <int> <int>
## 1 0 0 0 0 2549 0 0 0 144311 144311
## # … with 59 more variables: FROMDATE <int>, TODATE <int>, ADDRESS <int>,
## # LATITUDE <int>, LONGITUDE <int>, XCOORD <int>, YCOORD <int>, WARD <int>,
## # EVENTID <int>, MAR_ADDRESS <int>, MAR_SCORE <int>,
## # MAJORINJURIES_BICYCLIST <int>, MINORINJURIES_BICYCLIST <int>,
## # UNKNOWNINJURIES_BICYCLIST <int>, FATAL_BICYCLIST <int>,
## # MAJORINJURIES_DRIVER <int>, MINORINJURIES_DRIVER <int>,
## # UNKNOWNINJURIES_DRIVER <int>, FATAL_DRIVER <int>, …
## # A tibble: 1 × 58
## X Y CRIMEID CCN REPORTDATE ROUTEID MEASURE OFFSET FROMDATE ADDRESS
## <int> <int> <int> <int> <int> <int> <int> <int> <int> <int>
## 1 0 0 0 0 2549 0 0 0 560 192
## # … with 48 more variables: LATITUDE <int>, LONGITUDE <int>, XCOORD <int>,
## # YCOORD <int>, WARD <int>, MAR_SCORE <int>, MAJORINJURIES_BICYCLIST <int>,
## # MINORINJURIES_BICYCLIST <int>, UNKNOWNINJURIES_BICYCLIST <int>,
## # FATAL_BICYCLIST <int>, MAJORINJURIES_DRIVER <int>,
## # MINORINJURIES_DRIVER <int>, UNKNOWNINJURIES_DRIVER <int>,
## # FATAL_DRIVER <int>, MAJORINJURIES_PEDESTRIAN <int>,
## # MINORINJURIES_PEDESTRIAN <int>, UNKNOWNINJURIES_PEDESTRIAN <int>, …
## `geom_smooth()` using method = 'gam' and formula = 'y ~ s(x, bs = "cs")'
## `geom_smooth()` using method = 'loess' and formula = 'y ~ x'
## `geom_smooth()` using method = 'loess' and formula = 'y ~ x'
## `geom_smooth()` using method = 'loess' and formula = 'y ~ x'
